SELECT 
    MAX(MIN(c4)) OVER(PARTITION BY c8 ORDER BY c1  ROWS BETWEEN UNBOUNDED PRECEDING AND CURRENT ROW), c8 
FROM "t_alltype.parquet" 
GROUP BY c1,c8
